﻿18.4.2013 20:57:25
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 20:57:25
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 20:57:25', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 20:57:25
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:57:32
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:57:44
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:57:50
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:57:52
UPDATE Login SET 
logout = to_date('18.4.2013 20:57:52', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 348 

18.4.2013 20:59:24
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 20:59:24
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 20:59:24', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 20:59:24
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:59:28
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:59:30
select * from role order by name

18.4.2013 20:59:30
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 20:59:30
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

18.4.2013 20:59:30
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

18.4.2013 20:59:30
select * from role order by name

18.4.2013 20:59:34
select * from role order by name

18.4.2013 20:59:38
select * from role order by name

18.4.2013 20:59:42
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:59:45
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 20:59:46
select * from role order by name

18.4.2013 20:59:46
select * from role order by name

18.4.2013 20:59:46
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

18.4.2013 20:59:47
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 20:59:47
select * from company order by name

18.4.2013 20:59:48
select * from role order by name

18.4.2013 20:59:49
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

18.4.2013 20:59:49
select * from company order by name

18.4.2013 20:59:53
UPDATE Login SET 
logout = to_date('18.4.2013 20:59:53', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 349 

18.4.2013 21:01:38
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 21:01:38
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 21:01:38', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 21:01:38
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 21:01:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 21:01:46
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 21:01:47
UPDATE Login SET 
logout = to_date('18.4.2013 21:01:47', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 350 

18.4.2013 21:04:05
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 21:04:05
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 21:04:05', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 21:04:06
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 21:04:07
UPDATE Login SET 
logout = to_date('18.4.2013 21:04:07', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 351 

18.4.2013 22:24:45
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 22:24:45
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 22:24:45', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 22:24:45
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 22:24:48
UPDATE Login SET 
logout = to_date('18.4.2013 22:24:48', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 353 

18.4.2013 23:20:59
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 23:20:59
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 23:20:59', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 23:20:59
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:42:29
UPDATE Login SET 
logout = to_date('18.4.2013 23:42:29', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 354 

18.4.2013 23:42:40
select * from [User] where nameLogin = @nameLogin and password = @password

18.4.2013 23:42:41
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('18.4.2013 23:42:41', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

18.4.2013 23:42:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:43:26
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:43:26', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

18.4.2013 23:43:26
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:46:26
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:46:26', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

18.4.2013 23:46:26
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:46:45
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2', 
 idParent = '1', 
 orderModul = '20', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1.2', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:46:45', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 16 

18.4.2013 23:46:45
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:46:58
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:47:17
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2.1', 
 idParent = '16', 
 orderModul = '10', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1.2.1', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:47:17', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 19 

18.4.2013 23:47:17
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:47:31
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2.2', 
 idParent = '16', 
 orderModul = '20', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1.2.2', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:47:31', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 20 

18.4.2013 23:47:31
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:48:04
UPDATE Modul SET 
nameModul = 'Testovací modul 1.2', 
 idParent = '1', 
 orderModul = '20', 
 sqlQuery = '', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:48:04', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 16 

18.4.2013 23:48:04
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:48:27
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:48:40
UPDATE Modul SET 
nameModul = 'Testovací modul 1.3', 
 idParent = '1', 
 orderModul = '30', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:48:40', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 17 

18.4.2013 23:48:40
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:48:52
UPDATE Modul SET 
nameModul = 'Testovací modul 1.4', 
 idParent = '1', 
 orderModul = '40', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1.4', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:48:52', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 18 

18.4.2013 23:48:52
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:49:33
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.1', 
 idParent = '2', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.1', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:49:33', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 5 

18.4.2013 23:49:33
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:49:43
UPDATE Modul SET 
nameModul = 'Testovací modul 1.3', 
 idParent = '1', 
 orderModul = '30', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_1.3', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:49:43', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 17 

18.4.2013 23:49:43
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:49:49


18.4.2013 23:49:49
System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at DBManager.SqlManager.Select(String sql_, DataTable& dataTable_, Dictionary`2 parametry) in G:\ProjectsSVN\trunk\Pruzkumnik\DBManager\SqlManager.cs:line 236

18.4.2013 23:50:02
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:50:27
UPDATE Modul SET 
nameModul = 'Testovaci subsubmodul 2.1.1', 
 idParent = '5', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.1.1', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:50:27', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 10 

18.4.2013 23:50:27
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:50:41
UPDATE Modul SET 
nameModul = 'Testovaci submodul 2.2', 
 idParent = '2', 
 orderModul = '0', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_2.2', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:50:41', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 7 

18.4.2013 23:50:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:50:53
UPDATE Modul SET 
nameModul = 'Testovaci modul 4', 
 idParent = '0', 
 orderModul = '40', 
 sqlQuery = '', 
 nameApplication = 'Text.exe', 
 parametersApp = '-nazev=Testovaci_modul_4', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:50:53', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 9 

18.4.2013 23:50:53
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:51:07
UPDATE Modul SET 
nameModul = 'Testovaci modul 5', 
 idParent = '0', 
 orderModul = '50', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_5', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:51:07', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 8 

18.4.2013 23:51:07
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:51:25
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:51:38
UPDATE Modul SET 
nameModul = 'Testovaci modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_7', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:51:38', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 13 

18.4.2013 23:51:38
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:52:40
UPDATE Modul SET 
nameModul = 'Testovaci modul 4', 
 idParent = '0', 
 orderModul = '40', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_4', 
 userMod = 1, 
 dateMod = to_date('18.4.2013 23:52:40', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 9 

18.4.2013 23:52:40
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

18.4.2013 23:53:02
UPDATE Login SET 
logout = to_date('18.4.2013 23:53:02', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 356 

19.4.2013 0:31:54
select * from [User] where nameLogin = @nameLogin and password = @password

19.4.2013 0:31:54
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('19.4.2013 0:31:54', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

19.4.2013 0:31:54
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

19.4.2013 0:32:12
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = '', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('19.4.2013 0:32:12', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

19.4.2013 0:32:12
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

19.4.2013 0:52:00
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

19.4.2013 0:52:21
select * from role order by name

19.4.2013 0:52:21
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

19.4.2013 0:52:21
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

19.4.2013 0:52:21
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

19.4.2013 0:52:21
select * from role order by name

19.4.2013 0:52:44
select * from role order by name

19.4.2013 0:52:44
select * from role order by name

19.4.2013 0:52:44
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

19.4.2013 0:52:58
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

19.4.2013 0:52:58
select * from company order by name

19.4.2013 1:08:39
select * from [User] where nameLogin = @nameLogin and password = @password

19.4.2013 1:08:40
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('19.4.2013 1:08:40', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

19.4.2013 1:08:40
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

19.4.2013 1:09:28
UPDATE Login SET 
logout = to_date('19.4.2013 1:09:28', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 359 

19.4.2013 1:12:20
UPDATE Login SET 
logout = to_date('19.4.2013 1:12:20', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 358 

19.4.2013 19:59:18
select * from [User] where nameLogin = @nameLogin and password = @password

19.4.2013 19:59:20
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('19.4.2013 19:59:20', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

19.4.2013 19:59:21
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

19.4.2013 19:59:22
UPDATE Login SET 
logout = to_date('19.4.2013 19:59:22', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 361 

21.4.2013 20:51:49
select * from [User] where nameLogin = @nameLogin and password = @password

21.4.2013 20:51:56
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('21.4.2013 20:51:56', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

21.4.2013 20:51:57
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

21.4.2013 20:52:07
select * from role order by name

21.4.2013 20:52:07
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

21.4.2013 20:52:07
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

21.4.2013 20:52:07
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

21.4.2013 20:52:08
select * from role order by name

21.4.2013 20:52:09
select * from role order by name

21.4.2013 20:52:09
select * from role order by name

21.4.2013 20:52:09
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

21.4.2013 20:52:11
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

21.4.2013 20:52:11
select * from company order by name

21.4.2013 20:52:13
select * from role order by name

21.4.2013 20:52:13
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

21.4.2013 20:52:19
select * from role order by name

21.4.2013 20:52:23
select * from role order by name

21.4.2013 20:52:23
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

21.4.2013 20:52:27
select * from role order by name

21.4.2013 20:52:35
UPDATE Login SET 
logout = to_date('21.4.2013 20:52:35', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 363 

